const { DataTypes } = require('sequelize')
const seq = require('../db/seq')

//创建模型(建用户表)
const User = seq.define('User', {
    user_name: {
        type: DataTypes.STRING,
        allowNull: false,
        unique: true,
        comment: "用户名， 唯一"
    },
    password: {
        type: DataTypes.CHAR(64),
        allowNull: false,
        comment: "密码"
    },
    is_admin: {
        type: DataTypes.BOOLEAN,
        allowNull: false,
        defaultValue: 0,
        comment: "是否为管理员: 0为用户,1为管理员"
    }
})

//有表就删除
// User.sync({ force: true })

module.exports = User